insert into fz223_ppa.agency(id,full_name,short_name,inn,kpp,ogrn,address_id,status,IS_CUSTOMER,IS_CUSTOMER_REPRESENT,IS_CUSTOMER_DETACHED_DEPART,IS_SUPERVISOR,IS_RNP_MANAGER,IS_OPERATOR,CREATED_AT,UPDATED_AT,TIME_ZONE_ID, OKFS_ID,OKOPF_ID,OKATO_ID,OKTMO_ID,PHONE,WEBSITE,EMAIL,CONTACT_SECOND_NAME,CONTACT_FIRST_NAME,CONTACT_MIDDLE_NAME,FAX,ADDITIONAL_INFO,POSTAL_ADDRESS,CONTACT_EMAIL,OKPO_CODE,REQUISITES, IS_INT_ALLOWED) values( fz223_ppa.seq_agency.nextval, '&&FULL_NAME', null, '&&INN', '&&KPP', '&&OGRN', &&ADDRESS_ID, 'REGISTERED', 1, 0, 0, 0, 0, 0, sysdate, sysdate, 2, 21, 1, 410493, 27576, '&&PHONE', '&&WEBSITE', '&&EMAIL', 'Фамилия', 'Имя', 'Отчество', '5566666777777788', 'Дополнительная информация', 'Почтовый адрес', 'pgz223fz@yandex.ru', '112233', 'Реквизиты федерального закона', 0);